package icu.ikuns;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @Author： Kimariyb
 * @Date：2022/05/14/22:26
 * @Description：
 */
public class RecodeList {
    private int currentPage = 1;
    private int pageCount = 1;
    private int pageSize = 10;
    private int rowCount = 0;

    public String getRecordListPage() {
        StringBuilder sb = new StringBuilder();
        Connection conn = null;
        Statement sta = null;
        ResultSet rs = null;
        try {
            String sql = "select * from questions limit " +
                    String.valueOf(currentPage * pageSize) + "," + String.valueOf(pageSize);
            conn = DBConnection.getConnection();
            sta = conn.createStatement();
            rs = sta.executeQuery(sql);
            sb.append("<table width='90%' border=\"1\" cellpadding=\"2\" cellspacing=\"0\">");
            sb.append("");
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {

        }
    }
}
